General Ledger

In CMPClosed Converged Monetisation Platform. The MDS Global product that supports customer care and billing for digital service providers., the accountClosed In the Cloud Monetisation Platform, a billing entity that can be used to manage payments on one or more subscriptions or payments for services. An account can hold details such as payments or invoices. balance is held in a ledger system known as the Sales Ledger, which consists of all the invoices and payments relating to a particular account. The ledger system also includes a General Ledger, where the amounts due and payments received are allocated to various General Ledger accounts, depending on how a company wants to organise its financials. A general ledger is a set of numbered accounts that a business uses to keep track of its financial transactions and to prepare financial reports. Each account is a unique record summarising each type of asset, liability, equity, revenue and expense.

This job creates a batch detailing the daily breakdown of all payment, invoice, purchase and bond redemption information (along with an associated nominal code) for a particular calendar month.

The job provides an additional breakdown for certain items, for example recurring payments by payment type and invoices by tax rate.

The General Ledger job is run for a specific month and year. If no value is specified for the month or year, it is assumed that the job is being run for the current year/month.

The General Ledger job extracts the following based on the job run period:

  • Payments - The payments nominal code is specified at the top of the each Payments section in the General Ledger JSONClosed JavaScript Object Notation. JSON is a lightweight format for storing and transporting data, often used when data is sent from a server to a web page. output. The following breakdown exists within the Payments section of the JSON output:
    • Recurring - covers both successful and failed (reversals) recurring payment records accumulated by payment type (Direct Debit, VISA etc) for each day within the job run period. Failed recurring payments will appear as two records in the extract, one for the original payment and one for the reversal. These transactions may appear on separate days and in separate extracts based on when the payment was drawn and the reversal occurred.
    • Non-recurring - covers only successful one-off payments for each day within the job run period.
    • Online - covers only successful online payments for each day within the job run period.
    • Bond - covers only successful bond payments for each day within the job run period.
    • Refund - covers only successful refund payments for each day within the job run period.
    • Prepaid Balance - covers only successful payments from a prepaid balance for each day within the job run period.
  • Invoices - The invoices nominal codes are specified at the top of the Invoices section in the General Ledger JSON output.
    • Summary of tax - creates a record for each distinct day and tax rate. If there are multiple tax rates separate totals are accumulated for each tax rate.
    • Summary of the nominal charges - accumulates a total per day per nominal code.
  • Bond redemptions - a bond redemption summary record is created totalling bond redemptions for each day within the job run period. Zero totals for a day are not reported. The bond redemptions nominal code is specified at the top of the Bond Redemptions section in the General Ledger JSON output.
  • Purchases - a purchases summary record is created for each purchase type (prepaid, postpaid or balance) totalling purchases for each day within the job run period. Zero totals for a day are not reported. The purchases nominal code is specified at the top of the Purchases section in the General Ledger JSON output for each purchase type.

The nominal codes used in the General Ledger extract are defined in the General Ledger module properties. Once the General Ledger job has run, downstream daemons extract the batches of ledger records and convert them to the required external system format and transmit them to the required destination.

Typically, this job is scheduled to run once for a given calendar month.

The following daemonClosed A computer program that runs as a background process, rather than being under the control of an interactive user.(s) are associated with the General Ledger job:

Daemon Details
Extract General Ledger To Generic Format This daemon creates and encrypts generic CMP files, which are available for conversion to third party format.

The following probeClosed In the Administration Console architecture, a mechanism which allows for the execution of predefined queries and for the comparison of the results of those queries against pre-configured targets. Probes can be reviewed and managed via the Admin Console.(s) can be run against the General Ledger job:

Name Type Description
General Ledger Extract Completed Alert Alert probe that returns number of files produced by the General Ledger Extract Daemon today. If this query returns a value of zero, this indicates that no outbound files were produced and an alert will be sent to the recipients configured for his probe.
General Ledger Extract Completed SLA SLA probe that returns number of files produced by the General Ledger Extract Daemon today. If this query returns a value of zero, this indicates that no outbound files were produced and the SLA has been breached. Because this is an SLA probe, there is no email alert issued.

Relevant JSON schemaClosed A specification for JSON based format for defining the structure of JSON data.: